package com.linq.cool.beauty.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.linq.cool.beauty.domain.BeautyTopUp;
import com.linq.cool.beauty.vo.statistical.StatisticalVO;

import java.util.List;
import java.util.Map;

/**
 * @Author: yqlin
 * @Date: 2021/2/2 22:37
 * @Description:
 * @Version: 1.0.0
 */

public interface BeautyTopUpLogMapper extends BaseMapper<BeautyTopUp> {
    /**
     * 先查询近6个月的月份的收入统计
     *
     * @return
     */
    List<Map<String, Object>> statisticalMonthlyIncome();

    /**
     * 统计消费榜前10
     *
     * @return
     */
    List<StatisticalVO> statisticalTopTenSpenders();

    /**
     * 根据客户id查询出当前客户的最近6月份的充值情况
     *
     * @param memberId
     *
     * @return
     */
    List<StatisticalVO> statisticMemberTopUp(Long memberId);
}